CREATE TABLE [dbo].[wad_provincias]
(
[cd_provincia] [dbo].[_codigo] NOT NULL,
[cd_pais] [dbo].[_codigo] NOT NULL,
[nm_provincia] [dbo].[_nombre] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wad_provincias] ADD CONSTRAINT [PK_wad_provincias] PRIMARY KEY CLUSTERED  ([cd_provincia]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [FK_cd_pais] ON [dbo].[wad_provincias] ([cd_pais]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wad_provincias] ADD CONSTRAINT [FK_wad_provincias_wad_paises] FOREIGN KEY ([cd_pais]) REFERENCES [dbo].[wad_paises] ([cd_pais]) ON DELETE CASCADE ON UPDATE CASCADE
GO
